home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-04
/
ov_all.zip
/
TI704.ASC
< prev
next >
Wrap
Text File
|
1991-11-11
|
5KB
|
199 lines
PRODUCT : ObjectVision NUMBER : 704
VERSION : 1.0
OS : WIN
DATE : November 11, 1991 PAGE : 1/3
TITLE : Creating a Multiple Table Form In ObjectVision
This document explains how to use ObjectVision to create multiple
tables that can be accessed through one form. The following
steps demonstrate how to create the multiple tables using
ObjectVision and how you can access these tables using one form.
Step 1
1. Create a Master Form.
Tool|Form. (Name this form Master)
2. On this form, create the following field names, Customer Id
Number, Customer Name, Address, City, State.
3. Create a Link. Choose Paradox as the database format. Name
this link "First Link" (without the quotes). Let us call this
table custinfo. When prompted,"Create the appropriate buttons"
select "YES".
Step 2
1. Create a second Form called Detail One. This form is only
being used as a temporary storage place. Choose Form|New and
enter Detail One as the form's name. On this form create two new
fields, Detail Customer Name, Birthdate. Make Birthdate a date
field using Properties|Field Type. Select the date type you
would like to use from the selection list.
2. Create a Second Link. Select
Tools|Link|Create
Choose Paradox as the database format. Name this link "Second
Link" (no Quotation marks). Let us call this table, Birth. When
prompted if you want ObjectVision to Create Appropriate Buttons,
choose NO.
3. Select the form called Detail One. Cut and Paste all of the
fields from here to the Master Form. To select multiple fields
on the form, begin by clicking on the first field on the form,
press SHIFT and click on last field. Select Edit|Cut from the
ObjectVision menu bar. Open the Master form. Select Edit|Paste.
Locate this block below the fields that are already on the Master
form.
PRODUCT : ObjectVision NUMBER : 704
VERSION : 1.0
OS : WIN
DATE : November 11, 1991 PAGE : 2/3
TITLE : Creating a Multiple Table Form In ObjectVision
Step 3
1. Create a third form called Detail Two using Form|New. On
this form add the following fields: Detail Tracking Number,Item
Description, Item Price and Detail Customer ID Number.
2. Create Third Link. Select
Tools|Link|Create
Choose Paradox as the database format. Name this link "Third
Link" (no quotation marks). Let us name this database item.
When prompted, "Create Appropriate Buttons", choose "NO".
3. From the Detail Two form, copy and paste all of the fields
onto the Master Form using the steps described above in Step 2.
You may now delete the Detail One and Detail Two forms using
Tools|Stack. To delete a form, highlight the name of the form
then using Edit|Cut delete the form from the stack. Repeat these
steps to delete Detail Two.
Step 4
1. Put a decision tree on Detail Customer Name. Select Detail
Customer Name. Select Tools|Tree. From the Tree Menu Bar select
OBJECTS|Conclusion. The conclusion for this field is as follows:
+ Customer Name
This tells ObjectVision that Detail Customer Name will have the
same value as Customer Name. An ObjectVision field may only
receive a value from one table at a time. If you are linked to
multiple tables via links, you must have unique ObjectVision
fields to receive the information from the various tables, while
at the same time you want to ensure that each table is
referencing the same keyed field value.
2. Place the following tree on Detail Customer Id Number:
+ Customer Id Number
At this point, if you do not wish to display these duplicate
fields (Detail Customer Name and Detail Customer ID Number) on
the form, you can remove the field names and the field borders.
Select Properties|Field Type (deselect the display
PRODUCT : ObjectVision NUMBER : 704
VERSION : 1.0
OS : WIN
DATE : November 11, 1991 PAGE : 3/3
TITLE : Creating a Multiple Table Form In ObjectVision
field name box)
Select Properties|Borders (deselect the outline
box)
Shrink the fields down so they are as small as they can get.
Step 5
You will want to update the decision trees for the Master form's
button fields so they will update all of the databases at the
same time. For example the Enter Button would have the following
decision tree:
@Store("Link One") (using CTRL ENTER at the
@Store("Second Link") end of each line to add
@Store("Third Link") additional conclusions)
Do this for all of your button fields. You may want to add
additional Button fields that will only increment the database
you are trying to page through.